<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<?php
require_once './model/db.php';


?>
<h3>huynh ngoc thach</h3>
<?php 
    $query = "SELECT * FROM companies";
    $companies = getData($query);
    
?>
<form method="POST">
    Min fans<input type="text" name="min_fans">
    Max fans<input type="text" name="max_fans"><br>
    Keyword <input type="text" name="keyword">
    Company<select name="id_company"><br>
        <?php foreach ($companies as $company): ?>
        <option value="<?php echo $company['id'] ?>"><?php echo $company['name']?></option>
        <?php        endforeach;?>
    </select>
    <input type="submit" name="submit">
</form>

<?php if (isset($_POST['submit'])):?>
    <?php 
        $min_fans = $_POST['min_fans'];//TODO
        $max_fans = $_POST['max_fans'];//TODO
        $keyword = $_POST['keyword'];//TODO
        if (empty($keyword)){
            if (empty($min_fans)&&empty($max_fans)){
                 $query = "SELECT * FROM pages";
                 $pages = getData($query);
            }elseif (empty ($max_fans)) {
            $query = "SELECT * FROM pages 
                     WHERE (likes >= $min_fans)
                     LIMIT 0, 10
                 ";
            $pages = getData($query);
        }  else {
            $query = "SELECT * FROM pages 
                     WHERE (likes >= $max_fans)
                     LIMIT 0, 10";
             $pages = getData($query);
        }
        }else{
            if (empty($min_fans)&&empty($max_fans)){
                 $query = "SELECT * FROM pages
                         where(description LIKE '% $keyword %') ";
                 $pages = getData($query);
            }elseif (empty ($max_fans)) {
            $query = "SELECT * FROM pages 
                     WHERE (likes >= $min_fans)
                         AND (description LIKE '% $keyword %')
                     LIMIT 0, 10
                 ";
            $pages = getData($query);
        }  else {
            $query = "SELECT * FROM pages 
                     WHERE (likes >= $max_fans)
                         AND (description LIKE '% $keyword %')
                     LIMIT 0, 10";
             $pages = getData($query);
        }} 
var_dump($query);
    ?>

    <?php if (!empty($pages)):?>
    <table>
        <tr>
            <td> profile </td>
            <td> likes </td>
            <td> description </td>
        </tr>
        <?php foreach ($pages as $page):?>
            <tr>
                <td><img src="<?php echo $page['picture']?>"></td>
                <td><?php echo $page['likes'] ?></td>
                <td><?php echo substr( $page['description'],0,100) ?></td>
            </tr>
        <?php endforeach; ?>
    </table> 

    <?php endif;?>
<?php endif;?>
